/home/jessie/anaconda3/envs/gov_env/lib/python3.7/site-packages/geopandas/plotting.py:642: UserWarning: Only specify one of 'column' or 'color'. Using 'color'. "Only specify one of 'column' or 'color'. Using 'color'.", UserWarning
| index | nombrearchivo | secuencia | consecutivo | codigoruta | descripcion | longitud | latitud | passuben | pasbajan | fecha | horaregistro | velocidad | recorridoexito | file | año | mes | dia_semana | intervalo_2h | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 8909274373EQR83411072023062031 | 464532833 | 1 | 112375 | LAURELES NOGAL # 1 | -75.613068 | 6.245110 | 0 | 0 | 2023-07-11 | 1900-01-01 06:20:31 | 12.0 | True | Consulta EAFIT-Julio 11 2023-SMM.txt | 2023 | 7 | 1 | 1900-01-01 06:00:00 |
| 1 | 1 | 8909274373EQR83411072023062031 | 464532833 | 2 | 112375 | LAURELES NOGAL # 1 | -75.611855 | 6.245607 | 0 | 0 | 2023-07-11 | 1900-01-01 06:21:02 | 17.0 | True | Consulta EAFIT-Julio 11 2023-SMM.txt | 2023 | 7 | 1 | 1900-01-01 06:00:00 |
| 2 | 2 | 8909274373EQR83411072023062031 | 464532833 | 3 | 112375 | LAURELES NOGAL # 1 | -75.610413 | 6.245403 | 0 | 0 | 2023-07-11 | 1900-01-01 06:21:33 | 11.0 | True | Consulta EAFIT-Julio 11 2023-SMM.txt | 2023 | 7 | 1 | 1900-01-01 06:00:00 |
| 3 | 3 | 8909274373EQR83411072023062031 | 464532833 | 4 | 112375 | LAURELES NOGAL # 1 | -75.610344 | 6.245403 | 0 | 0 | 2023-07-11 | 1900-01-01 06:21:37 | 0.0 | True | Consulta EAFIT-Julio 11 2023-SMM.txt | 2023 | 7 | 1 | 1900-01-01 06:00:00 |
| 4 | 4 | 8909274373EQR83411072023062031 | 464532833 | 5 | 112375 | LAURELES NOGAL # 1 | -75.609840 | 6.245478 | 1 | 0 | 2023-07-11 | 1900-01-01 06:21:52 | 31.0 | True | Consulta EAFIT-Julio 11 2023-SMM.txt | 2023 | 7 | 1 | 1900-01-01 06:00:00 |
| hora | promedio pasajeros suben | |
|---|---|---|
| 0 | 00:00:00 | 5.454545 |
| 1 | 01:00:00 | 0.782609 |
| 2 | 02:00:00 | 1.526316 |
| 3 | 03:00:00 | 34.619048 |
| 4 | 04:00:00 | 78.940789 |
| 5 | 05:00:00 | 150.208092 |
| 6 | 06:00:00 | 172.270115 |
| 7 | 07:00:00 | 137.960227 |
| 8 | 08:00:00 | 105.516854 |
| 9 | 09:00:00 | 98.825581 |
| 10 | 10:00:00 | 92.305882 |
| 11 | 11:00:00 | 97.110465 |
| 12 | 12:00:00 | 97.658960 |
| 13 | 13:00:00 | 97.179191 |
| 14 | 14:00:00 | 105.894118 |
| 15 | 15:00:00 | 119.843931 |
| 16 | 16:00:00 | 137.429379 |
| 17 | 17:00:00 | 138.738636 |
| 18 | 18:00:00 | 115.059172 |
| 19 | 19:00:00 | 72.078313 |
| 20 | 20:00:00 | 44.592105 |
| 21 | 21:00:00 | 26.804511 |
| 22 | 22:00:00 | 13.541667 |
| 23 | 23:00:00 | 2.906977 |
| hora | promedio pasajeros bajan | |
|---|---|---|
| 0 | 00:00:00 | 1.431818 |
| 1 | 01:00:00 | 0.826087 |
| 2 | 02:00:00 | 0.315789 |
| 3 | 03:00:00 | 29.349206 |
| 4 | 04:00:00 | 67.763158 |
| 5 | 05:00:00 | 139.208092 |
| 6 | 06:00:00 | 163.839080 |
| 7 | 07:00:00 | 139.846591 |
| 8 | 08:00:00 | 108.016854 |
| 9 | 09:00:00 | 95.058140 |
| 10 | 10:00:00 | 87.794118 |
| 11 | 11:00:00 | 92.691860 |
| 12 | 12:00:00 | 91.907514 |
| 13 | 13:00:00 | 92.023121 |
| 14 | 14:00:00 | 95.517647 |
| 15 | 15:00:00 | 106.942197 |
| 16 | 16:00:00 | 120.372881 |
| 17 | 17:00:00 | 126.755682 |
| 18 | 18:00:00 | 107.869822 |
| 19 | 19:00:00 | 77.897590 |
| 20 | 20:00:00 | 52.223684 |
| 21 | 21:00:00 | 29.631579 |
| 22 | 22:00:00 | 15.566667 |
| 23 | 23:00:00 | 5.732558 |
| fecha | hora | codigoruta | cantidad | |
|---|---|---|---|---|
| 0 | 2023-03-14 | 03:00:00 | 110242 | 2 |
| 1 | 2023-03-14 | 03:00:00 | 110252 | 1 |
| 2 | 2023-03-14 | 03:00:00 | 110355 | 1 |
| 3 | 2023-03-14 | 03:00:00 | 110425 | 2 |
| 4 | 2023-03-14 | 03:00:00 | 110615 | 5 |
| ... | ... | ... | ... | ... |
| 22822 | 2023-08-30 | 23:00:00 | 110742 | 1 |
| 22823 | 2023-08-30 | 23:00:00 | 110752 | 1 |
| 22824 | 2023-08-31 | 00:00:00 | 110782 | 1 |
| 22825 | 2023-08-31 | 00:00:00 | 111415 | 1 |
| 22826 | 2023-08-31 | 00:00:00 | 120692 | 1 |
22827 rows × 4 columns
/home/jessie/anaconda3/envs/gov_env/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
| hora | velocidad promedio | |
|---|---|---|
| 0 | 00:00:00 | 2.005690 |
| 1 | 01:00:00 | 0.393921 |
| 2 | 02:00:00 | 0.014530 |
| 3 | 03:00:00 | 9.489936 |
| 4 | 04:00:00 | 10.740703 |
| 5 | 05:00:00 | 9.460708 |
| 6 | 06:00:00 | 8.277617 |
| 7 | 07:00:00 | 7.822308 |
| 8 | 08:00:00 | 7.530643 |
| 9 | 09:00:00 | 7.414085 |
| 10 | 10:00:00 | 7.179747 |
| 11 | 11:00:00 | 7.136564 |
| 12 | 12:00:00 | 7.204948 |
| 13 | 13:00:00 | 7.135577 |
| 14 | 14:00:00 | 7.050081 |
| 15 | 15:00:00 | 6.625561 |
| 16 | 16:00:00 | 6.402883 |
| 17 | 17:00:00 | 6.437497 |
| 18 | 18:00:00 | 6.973490 |
| 19 | 19:00:00 | 7.833711 |
| 20 | 20:00:00 | 8.729982 |
| 21 | 21:00:00 | 8.766529 |
| 22 | 22:00:00 | 8.595890 |
| 23 | 23:00:00 | 6.225116 |